package com.five.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.five.pojo.Club;
import com.five.pojo.ClubJoin;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author lenovo
 */
@Mapper
public interface ClubDao extends BaseMapper<Club> {


    List<Club> list2(String cName , String cType);

    //申请入团
    @Insert("insert into clubJoin(s_name , s_phone , s_class , s_gender , c_name , c_type , c_jointime) " +
            "values(#{sName} , #{sPhone} , #{sClass} , #{sGender} , #{cName} , #{cType} , #{cJoinTime}) ")
    void addClub(ClubJoin clubJoin);

    //查询入团申请信息
    @Select("select * from clubjoin")
    List<ClubJoin> getAllJoin();
}
